SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479948 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479948 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918220,597509,1029667,448056,1034862,189194,83577,961240,809584,838326,271091,544447,796575,540473,51350,642386,693179,914476,539609,367872,795890,487603,837306,437959,566890,690666,732668,786526,458693,522860,58975,982479,372781,219033,226563,860444,1039078,472374,762889,1047852,152469,213867,678192,91656,877175,600067,585847,646483,543479,663031,454600,893804,476046,970607,918663,968915,1009797,201997,291583,983430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]