SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517856 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517856 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780358,644562,590788,257292,1007555,169042,442789,350414,332510,392144,699615,1009842,845908,344044,91152,811971,999210,336883,217423,627027,628882,664395,832071,362707,383077,534109,378083,56418,855563,903375,679964,568804,96857,737600,665990,1029132,105353,640896,982955,284023,447741,723713,864991,282436,448275,168825,864988,476604,534401,463587,318423,627540,35298,423947,223915,478049,788679,96360,712963,868793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]