SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532154 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532154 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642163,9334,102210,1019803,741819,891926,304240,143609,1009299,278256,548531,401717,712413,726462,659527,11953,414762,557474,981792,460533,750481,840598,183030,425502,1039341,977916,1707,487842,715932,54871,972987,723028,1011569,80698,666260,139665,151439,712952,25013,604384,233352,393473,890370,981021,565201,313420,585157,229309,404336,57690,911296,655733,844757,300589,582390,889115,273071,140408,854641,562586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]