SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35520 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35520 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72483,200358,21718,234914,689539,541060,598648,104516,911697,723923,126504,900659,725185,790483,711038,1031038,15879,452565,169487,988040,519356,830998,81962,763158,237431,385898,221269,212607,1023856,247132,881111,373352,995186,873982,435234,667011,703488,590119,214659,44862,792524,856347,492749,695355,289791,963275,1005712,277253,253789,420610,344325,227028,972281,101795,484052,117890,26035,690574,1034993,804399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000960s ]