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` = 507493 LIMIT 1 [ RunTime:0.001469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507493 [ RunTime:0.005163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412601,602831,343925,476654,336851,305792,952587,446520,78607,544819,899711,1046604,12075,257778,63093,680191,821835,689976,1003999,724610,751415,14271,443860,488053,827007,65285,233162,240335,268584,30362,766902,774360,678706,690164,250133,545935,470910,576900,228088,180894,297853,788318,384715,861213,301713,401085,438957,509136,770250,664999,574041,510185,674839,169779,57025,1024252,631110,195546,708397,643603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]