SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431812 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431812 [ RunTime:0.003352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644267,1045386,638212,909586,375022,325804,160888,733237,141701,1035831,421687,557802,405692,303478,444098,997051,774785,679400,779012,485000,226484,935758,79217,400728,843284,649566,720873,354161,169527,649315,776659,786333,633215,681623,313462,953779,243317,567760,663906,150283,843970,152119,224377,492855,549133,3160,954289,7816,30231,967123,453166,197414,335991,401912,302554,548803,924677,352195,798811,420378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]