SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108840 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108840 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931227,259576,969971,859808,140635,384297,271746,525989,766944,650498,936919,916612,959040,986375,250530,1002102,136872,632126,116061,24274,798593,136459,865241,925421,372938,963628,833122,232751,984063,352198,423958,153745,961839,772453,761049,714764,311001,168713,877645,73544,480379,104482,640543,339961,197884,544483,713148,777186,714116,273169,227166,326799,81517,92449,617351,104370,449431,246045,612782,561324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]