SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549822 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549822 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714119,589616,1025058,327791,390943,1021921,902626,626461,704936,3370,633686,563067,590896,708113,345444,992023,174719,341624,615890,922065,606672,363245,633860,1045489,719183,914602,705830,507970,223089,76203,763513,25782,147576,788611,528309,995330,558811,426964,434026,680994,650807,551920,912087,640798,14270,389684,623259,440162,268326,1047028,932569,895600,382059,260201,775858,23633,924397,89014,955449,806215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]