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` = 914860 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914860 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822363,690244,425962,302350,908885,677414,742913,226607,468766,146676,936942,237075,117998,454312,369501,59181,379434,269103,111902,402936,168347,1005014,175648,729363,541967,861042,104093,281911,14244,326438,631574,1020983,296824,294081,642666,356638,674514,202765,125160,899098,823198,685201,319850,242908,201469,905986,277489,865767,986565,959755,270554,384596,164892,1014792,832067,97261,765783,877540,279374,596825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]