SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138043 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138043 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601021,142841,85030,302705,69340,1034546,790014,133886,914199,660609,475186,419061,501457,487120,776159,692778,410439,764960,974923,263991,919346,320763,693427,441721,925618,462612,190252,932321,554807,492777,357838,423437,419233,855810,494390,774111,574530,421494,201094,896180,628475,259845,601671,587039,796695,683731,1041345,376072,943844,719275,248118,573083,1000260,949880,385735,726962,522882,456159,738230,75981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]