SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535851 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535851 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031489,747887,405352,748038,465962,115165,909797,143159,638354,398974,135589,690177,456424,284107,143015,817730,741932,152948,655911,819151,1025013,467437,219235,254587,738922,139816,878290,755093,187647,894109,380893,552922,68243,720724,452661,428847,212264,447127,560215,551046,1001481,540483,642049,75143,194489,1000176,277055,694759,1003768,709583,285559,628196,736804,96310,278256,92273,545703,1000244,275259,336083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001369s ]