SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201730 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201730 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851616,243196,232872,542329,414263,770379,32121,788644,361383,705252,370931,1025374,308242,501731,747841,996041,718586,947361,176521,222450,555864,821378,760074,486043,831480,250787,693140,867227,137537,210127,860636,327459,823173,282444,532599,826238,383419,8219,426212,566653,398942,871160,547385,358288,50118,134919,16334,241124,605895,538292,6189,454844,841842,251234,128725,790253,422111,62954,848971,572974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]