SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453987 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453987 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374452,309133,633152,278260,565561,555844,32370,56723,822150,122368,3196,246595,69293,633917,791110,810142,370436,848327,951202,820129,467825,378368,705670,101219,167829,529176,430712,484963,537602,122762,622078,1046175,224647,60963,452631,576363,136197,514920,968296,258098,339195,251367,502715,274392,227139,983667,515388,521520,928667,79355,687702,247448,1010975,136457,445848,771504,242134,72989,419988,268574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001731s ]