SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004890 LIMIT 1 [ RunTime:0.001334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004890 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197409,31202,854440,308583,686973,440838,90067,376417,231317,580243,555965,751073,380053,1021863,180950,839624,248798,322891,764903,268596,940586,193726,75716,9809,710510,11791,61397,891317,155367,739803,234173,935176,225839,658245,708333,831090,442165,760965,414539,362609,259635,953506,767149,162516,387462,1046204,740684,49158,257264,1024739,45290,173359,257111,636136,833499,246268,1022830,904159,966547,623367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]