SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531600 LIMIT 1 [ RunTime:0.001360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531600 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687719,561481,446997,348277,365445,252743,481581,756378,45112,81892,958382,36015,566569,174766,752061,474126,523546,1035439,594674,76136,574751,999069,996274,370697,377100,1019786,1039924,564923,126381,413971,555388,605500,119200,193902,625812,506603,102502,518561,927817,920321,192288,522439,66280,213254,439640,352839,60440,578021,533529,804074,908928,594134,541473,825868,350652,268877,137342,332965,615689,596516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]