SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249609 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249609 [ RunTime:0.005913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101307,619462,686240,73409,565719,916076,837187,47465,497559,253378,578390,515150,121028,782772,370754,614678,747861,505653,839060,180382,874044,1028605,342646,383170,293701,735720,793487,794966,591381,164940,866676,209042,30042,650719,407284,394684,994560,673418,603736,642208,526410,659595,253844,521077,528657,486207,966420,1003618,497612,641179,839467,740769,681994,691070,544489,576752,902214,307993,529895,244188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]