SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494489 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494489 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542201,506874,798273,741403,49559,209144,753717,57212,243801,71436,523918,299497,275377,576254,970770,894335,294019,324159,140212,536779,912438,839882,173164,961780,909957,875041,147421,645850,783910,924184,899134,1031567,478879,758476,895226,134374,875362,315839,345623,171680,122015,504833,61228,173237,35495,636189,325338,65295,1013961,104349,966576,794925,518945,489221,327968,822832,353395,885598,824449,9646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]