SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504327 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504327 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256532,135995,142212,314101,797212,962529,843859,762832,426593,617834,603084,586519,633209,519300,218129,526287,789280,999362,298527,667126,459145,441775,614937,950634,77866,117934,675251,480136,749387,630620,165609,346004,799474,188193,789342,448474,68993,664856,470010,737462,136196,161343,633514,288571,760013,675974,388209,1015549,1039929,905793,749649,304941,50915,312331,1003883,40613,473682,696198,7039,981928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003120s ]