SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455001 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455001 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014636,854844,598619,276532,244462,642992,708457,80446,697341,72319,672964,46918,78324,457397,426468,294561,16384,279634,690625,301910,450104,541584,129553,266262,1037752,686360,957941,578762,330004,308026,211264,447534,794426,666674,94350,151680,238387,557163,446718,21842,948538,200290,57503,392015,420548,39581,993135,144053,782709,881443,572804,332250,583551,1111,348885,1031169,483534,822299,357077,958627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]