SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403985 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403985 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138091,842049,680441,192949,885808,555049,185261,180129,1025752,415856,959801,381673,852710,208244,456530,738733,1020797,133002,727366,7603,10978,888522,810547,697532,375477,890947,43560,232675,148474,922730,234737,771032,442310,1037401,844,99171,967324,893768,643201,522573,786788,914688,1010251,216665,485503,369471,80682,572641,444414,787578,817026,521164,843790,220623,637234,689202,928736,721687,446629,154972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]