SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19407 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19407 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621061,326292,728354,983544,713550,817271,952078,544795,392513,617232,929708,154243,593178,766429,260236,972112,336470,743845,954228,520392,701579,793304,353640,34679,39197,21836,328115,9754,268813,289976,448857,192515,815593,982793,835374,1003209,580548,973633,633391,162553,494528,122611,715012,382506,568213,711552,669980,337134,313991,312211,26175,276989,463589,127834,772046,423174,295616,299097,814567,642178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]