SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291310 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291310 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006652,493471,844272,660275,356766,448223,41986,630884,312598,129484,688760,389846,803540,3892,648401,9413,563066,337542,801520,726826,782339,703054,134064,219953,946112,538173,309768,247100,806286,372045,69613,452491,74587,503721,22410,642557,108762,308247,549042,192156,297292,32250,76409,67744,442904,168748,964183,531154,562955,505983,509506,324732,898725,715534,751964,693874,927205,369423,140553,733339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]