SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309195 LIMIT 1 [ RunTime:0.002385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309195 [ RunTime:0.003054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407912,574157,936886,631095,536433,470608,553678,868126,851151,843238,624410,107180,345489,262544,121015,991594,746128,656441,207735,181830,701940,979089,406226,223512,305974,709331,957893,119559,323652,880273,58779,907153,413965,46246,724740,122650,761538,588253,245766,517729,788601,561809,649,985612,224176,773379,871775,691207,991937,21737,192854,503277,532053,836676,697644,811541,725733,366980,244069,1039545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]