SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323311 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323311 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982347,636902,828052,357995,820368,830791,141482,249303,225504,648639,172030,376034,175288,40560,297438,575128,521714,110413,84372,455728,345756,806688,3102,687100,918846,703851,108451,929990,454833,680848,264251,447606,12164,584220,259550,217974,226126,852097,858739,277166,497947,124538,370452,358489,535560,682658,3899,894549,62109,341742,16477,753284,172896,841000,1028514,763306,48680,203124,538825,675743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]