SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534090 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534090 [ RunTime:0.004162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373855,188557,573292,301036,971510,176531,959481,264769,909321,285636,653089,216118,463149,1021067,947591,834596,283584,709834,765146,660565,461853,373308,900289,120660,22029,155465,448817,1043250,424469,912351,679958,25863,782648,557880,744550,623073,448976,335487,346066,666500,791187,154957,891164,401689,988400,542510,915644,277569,128006,125661,874122,276715,369240,218935,126725,412146,869257,336565,984921,646832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]