SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330416 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330416 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360983,325247,285807,984129,762921,83879,647265,1024584,757112,891895,285285,943793,667821,2012,242027,1025814,686921,833924,320880,360888,452138,969447,1004058,982061,342615,372017,601399,521127,737802,71423,696754,735713,602686,677528,553414,53354,816430,267425,1007182,52346,720150,598369,946785,992199,259956,1015500,888941,897425,681769,391158,937622,710070,207548,111631,985524,106218,979342,164019,1026486,133786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]