SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535536 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535536 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905305,820116,451496,834680,252839,588517,943426,761042,2375,685144,100989,584512,377538,359302,239492,602729,523627,210985,1007196,747082,887195,443279,249157,840990,173242,705050,742790,811299,891064,289389,523348,188455,290356,808651,173962,837180,482994,543859,871906,18185,595581,470276,246207,50874,251496,847707,261036,539840,480782,972951,797534,158512,440353,93209,30676,712571,492163,214984,491988,671822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000772s ]