SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488164 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488164 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491882,911329,423481,531174,267638,326236,973265,912650,139765,256805,300938,458913,481611,536511,1002450,913651,902219,300488,668957,127853,131250,128033,822424,791350,548849,394111,340872,578973,477513,447296,441205,431092,186517,190766,717998,578932,468687,155349,713470,82059,784158,564829,952337,432932,55669,478091,67504,455914,499826,880033,951019,900340,7024,439057,218858,314030,905805,990617,401058,180866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]