SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403197 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403197 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480070,374178,358704,951119,610014,838367,264738,400875,849584,124784,1009214,494071,967576,249235,920507,245633,722867,117255,106236,937864,462705,95404,617057,122585,184951,410518,70413,588473,717833,1048371,947476,981209,514948,888645,341819,348362,458541,94958,558542,710278,701893,901321,1042974,983528,832316,812690,48336,648647,560994,1042380,84776,107683,670539,788459,833222,482121,792385,450255,758695,1010762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]