SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491096 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491096 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101098,375754,405072,566593,102114,326545,179224,407717,817889,319931,785585,1037928,119538,1011974,808492,815814,951251,271807,792402,29998,463715,761100,208971,32806,901817,105455,405882,710001,243804,923978,172850,136671,294919,771820,392208,263116,76960,10832,488852,819774,774862,983936,420528,39313,936000,1030151,388927,417079,2638,698233,570752,902375,459290,1008904,298360,854877,512780,181069,80372,921103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]