SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510509 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510509 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404102,279901,222739,302121,731187,157819,525146,869028,159519,375168,883215,197156,674048,166812,676101,362870,51901,428274,244266,83493,21055,443323,570007,460498,957230,600539,983375,389572,982745,806640,882753,473726,457374,386188,89292,186616,722141,90643,386888,45213,239711,599074,760649,730223,806533,102283,173684,633132,554986,117358,272410,600822,972699,363698,599743,370439,569188,320567,377146,833446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]