SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412019 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412019 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69016,69950,473504,656253,760247,937222,156184,613898,62453,72927,937672,991582,147377,925594,887778,221065,603260,876426,367200,937143,869973,380534,177765,1032688,5065,720843,211523,66953,544345,55096,826201,349398,482884,121948,350010,907893,163493,70291,1037742,341092,338859,229581,669859,901199,474258,457114,776676,292331,1030479,428672,356644,378726,1992,661807,91492,332476,157863,713683,170740,413557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]