SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026636 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026636 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705580,84949,26807,671246,350600,847357,658524,460416,369915,550003,259763,20178,760796,451168,883856,294598,381235,316076,645528,884155,47596,831914,22578,258016,524344,3611,579266,679921,137502,594455,359648,232542,727716,1021639,544035,231688,678917,403731,724793,817761,496052,952965,980534,306495,642688,159878,1016747,132978,451567,645994,450958,240261,271801,132676,75732,827917,850691,688189,34852,521051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]