SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544032 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544032 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79971,950129,715104,674215,81546,350566,22910,732809,436439,235630,222020,898271,502472,592314,736142,400180,601989,50279,143878,90125,608639,705886,768787,179802,48030,1044470,241278,132993,1020659,645692,499356,479065,85231,922882,231567,240723,923177,1021456,501735,503225,102307,775649,748933,1047892,317471,890964,394820,410822,171269,220003,621805,128380,604232,1021948,539600,312244,801455,1009042,366935,895539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001592s ]