SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504782 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504782 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734808,650922,517664,983934,871809,734045,326007,1047395,970010,152352,390097,642273,921553,548758,724227,502849,116558,212566,180265,353540,42177,2502,84222,735676,977736,463928,768071,387169,398122,484094,287735,543206,638961,797570,207723,588452,874155,272223,779835,97541,133518,412680,569781,680321,84216,50582,840917,119242,916976,382110,869917,427397,469087,639293,342317,613917,781663,783940,261160,462388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]