SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527983 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527983 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914009,733654,542429,380603,744967,883571,424916,105396,665567,969996,364837,995290,368280,700564,178866,970633,337208,857603,154569,157943,492919,367389,36030,131695,891315,36251,717403,574622,16414,888772,917602,1022,723099,850414,301959,169475,347053,691643,975189,718419,936743,396495,467832,991207,604755,498983,1004120,620860,48269,688839,812630,370218,387904,588546,560846,361535,681928,693270,563090,314488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]