SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396194 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396194 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230092,489571,196709,111253,267219,147064,732998,761663,199742,108908,151324,328855,253710,257471,869359,756989,945586,510273,961184,71411,22044,918055,123733,199725,905135,779844,919826,963545,445882,322835,107799,981870,867243,954755,689959,876389,492880,732619,827405,820322,517158,574299,579105,343823,762000,749869,58866,71294,812654,464072,798953,293343,87623,546502,231681,921213,586643,19823,743847,382098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]