SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804173 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804173 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423206,778803,370009,763101,391189,789586,683168,905834,743877,539696,906880,275876,36714,110147,714782,746218,341066,205404,953713,731441,98918,669530,66990,616614,947592,971356,984873,669263,955856,384603,604932,182154,840684,1043434,960600,973438,944807,185317,950976,676220,578393,371968,276861,990429,279074,372015,224925,198746,728967,779470,507363,768345,742596,42786,108673,719516,697658,262444,950546,406046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]