SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380913 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380913 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293003,526510,838748,875948,854572,524810,931163,357153,385669,914674,455309,807559,768705,147555,692245,406086,209078,1017161,732816,668382,547258,120007,620006,283284,69121,884933,65626,304125,991192,81112,395170,1007477,888927,618654,153659,865658,892275,972129,395273,239462,306326,115754,540869,264030,328300,37615,315437,1022666,973626,35213,643306,377663,709205,366808,34112,63004,305614,540479,1016417,200342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001497s ]