SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529138 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529138 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950082,775475,143349,536692,545318,215847,239700,822916,893205,838633,165140,204924,812654,520987,355397,864434,251069,554591,95155,105925,145902,575764,854190,656292,263846,237894,404154,128961,829566,1028319,172608,254480,729205,723919,992871,61680,558685,839516,859032,605789,1040009,773260,854168,313506,54964,831986,800449,936987,53952,763427,629274,828730,212060,1042758,199867,130066,568278,58290,723796,1027981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]