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` = 567833 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567833 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949057,355326,26424,189540,333833,207945,90366,117210,638899,982990,433918,450745,225040,750972,136022,458567,538826,338842,698788,555271,755204,313906,1017664,120867,427139,618403,233196,640534,607709,272940,996255,387375,159723,456722,644786,620676,289199,451592,16542,798600,21762,422717,381958,109815,1025099,235714,414584,334149,53887,743646,253637,884030,659684,983186,658695,802280,552627,535127,982961,362396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]