SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015294 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015294 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561784,705195,784205,686810,337336,297123,872547,338415,360864,694058,410393,623765,22303,248224,12337,13176,14112,965187,446646,586985,1010081,284201,473589,83551,104075,201356,771118,657775,207765,650199,195402,612509,507874,1047492,12771,762640,909241,1028596,399932,751480,661305,942681,685187,27102,48458,569417,912089,578843,7968,24017,518217,992750,135703,351883,476435,478365,488003,854945,233984,847875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002157s ]