SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003104 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003104 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51520,534454,396361,1006164,929793,970618,828109,476486,996578,145971,824918,372682,838833,901131,920,873649,477223,479112,670746,953325,671656,367961,606934,635999,125351,709082,616933,872153,889923,902475,419902,317471,302195,590238,878120,843952,850388,202183,376959,78562,40404,885366,908117,705916,635488,741742,562420,505705,423985,876554,672248,574760,811729,413546,472377,592765,271259,513953,921032,927784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003692s ]