SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298028 LIMIT 1 [ RunTime:0.002323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298028 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596685,447647,133087,1014944,87723,526991,514991,77707,109738,473553,1013448,521296,303728,369349,94078,1039511,935863,196160,587359,80327,49459,353947,849119,859931,654800,769173,584535,428905,350923,589219,832263,386486,74896,24537,235436,890929,228126,970535,5652,262247,722743,885793,843504,631381,1048218,730957,831860,403504,637917,453691,958431,44324,994118,133404,712359,779549,257646,486722,1043560,466321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]