SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456029 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456029 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243064,373175,658215,929017,454590,422735,343336,929170,843996,700829,55705,648435,1033923,1200,856704,960831,729020,824416,626455,135767,272070,985089,1009867,836955,1019423,550876,707633,861237,622070,633487,950150,633650,586207,715450,367716,632506,863660,37935,170845,539778,286646,490413,112635,702269,135268,92768,67695,314887,473006,502243,590286,1013807,793147,997697,323483,433962,604648,375799,945196,766812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001641s ]