SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405678 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405678 [ RunTime:0.004112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018051,127229,375195,366716,974182,741333,963901,432486,455808,735806,1023143,290924,434272,916482,798914,846199,720430,230879,719282,443159,523057,221371,390561,244290,252759,528699,629170,370173,77109,229034,81650,528378,740941,141314,1031276,767985,999844,466926,855594,237357,153730,259568,473831,473718,743574,700495,62248,921607,129992,949845,549709,329023,15157,510661,1011948,10363,78243,570901,702050,310213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000910s ]