SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40289 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40289 [ RunTime:0.003135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225116,733267,970662,75382,193174,72932,363305,281409,673158,1008084,492703,885708,407029,177387,121026,525290,211050,564195,74530,783755,819439,475231,396537,667102,421695,305459,920555,841493,939046,439673,663299,644395,312476,950897,345316,1035731,193625,529741,74079,220280,230175,864453,841604,653879,592667,916084,419706,449726,532201,455953,416464,443152,721458,731627,806837,415344,812384,964881,840299,937531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003716s ]