SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195413 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195413 [ RunTime:0.004108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400763,202057,1039531,800493,354473,58373,779741,661434,657281,955131,717098,645368,845764,246822,82436,477555,23553,495892,1043953,392356,1033227,108307,920700,8995,904506,204838,458528,50873,695735,217377,610675,83669,760216,741284,303848,1041635,1021799,769429,97357,233639,759683,487161,208717,558685,136509,618906,628222,576100,845031,607882,79690,804504,52983,105551,811157,1048694,554619,1043276,256021,402368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004316s ]