SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041171 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041171 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799723,457517,211777,758808,436930,987795,278935,175765,816281,429688,387648,788962,434643,438169,864354,936236,243005,362623,783939,510727,972893,476553,267923,53845,316719,910750,783632,876866,319454,964634,671544,206048,104946,460476,253584,799529,164612,811490,682418,667247,150404,108484,12435,840913,450059,660971,824862,212431,188915,915871,914765,514485,529070,485498,191981,714772,495627,1017733,54937,355071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000997s ]