SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025555 LIMIT 1 [ RunTime:0.003093s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025555 [ RunTime:0.003012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398297,47650,538572,487706,812405,489228,542165,910818,510492,66385,390096,140890,563645,833346,77087,565357,54105,142922,28985,248231,534266,10961,727275,630814,229747,603346,528162,1017067,561385,536448,386366,579434,93825,649151,108828,256690,625708,467094,286132,366905,787327,180229,839680,91443,176966,968100,994038,181110,694256,437899,404265,659475,362515,317416,122055,519964,802762,825804,687440,906944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]