SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545068 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545068 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321128,760675,525047,205950,33192,522514,212918,301913,580273,683864,661715,924207,511486,804330,834138,385910,1005484,803120,449025,979306,517435,512779,597483,264011,309442,266345,562395,978347,178015,350874,121546,15361,646605,205256,968147,690588,1011758,209394,485919,1046665,622686,391947,851469,824982,797481,990777,530741,641052,748057,144952,542122,585807,570676,9768,728865,280084,492354,719385,898552,346632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]