SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020041 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020041 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370838,158776,928943,505625,816106,906027,554046,774665,383832,448457,373966,471560,278853,308608,1044046,878106,906087,454742,25243,678719,538681,435692,253990,787269,604975,886519,43006,219590,670417,811833,3905,990902,841552,485677,893654,136326,425114,249744,213433,1032442,226628,193654,108131,605956,423534,1017184,379701,526446,1027123,579874,273085,760766,1003300,1012077,604324,20814,463530,30733,1043248,1044714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]