SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100532 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100532 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122769,316640,474041,783050,976155,1028634,979082,800128,479825,105953,682307,413321,16208,135163,65373,755679,806825,229910,503831,540396,417780,643609,80866,560185,1036981,468566,429597,1032828,815435,678482,331788,30213,534155,499567,397431,472533,583737,93148,825045,834087,705419,758715,674563,480446,789289,129918,165700,762065,482544,912244,322479,757999,200817,716864,315590,6309,50900,261151,645492,290638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]