SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5288 LIMIT 1 [ RunTime:0.001473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5288 [ RunTime:0.008231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509787,985099,786216,567232,429123,41662,807585,302272,156976,303155,132723,237197,816460,450178,106559,853877,705169,814489,104587,381794,185918,45022,68281,105573,611291,388209,555901,192574,312675,14333,232477,317729,323610,137941,899422,1002651,150057,681322,23363,385384,311284,16543,454349,418747,348270,28212,437784,359163,737158,172227,1006458,989929,941373,632543,483345,178871,124838,337834,623425,651409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]