SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154404 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154404 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467802,40511,98202,510802,959812,137036,487287,818574,216036,358984,214542,975414,239447,510325,330499,700881,245420,893821,805033,749701,370962,14989,964919,24142,466728,557754,349502,52465,805499,942257,667782,454324,806964,801518,105751,340514,205938,637975,1046914,196117,873038,115123,437191,81457,321578,252699,970240,162341,147184,65256,239167,320138,337652,602775,156096,970430,693286,278572,285523,214827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]