SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503889 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503889 [ RunTime:0.003073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335138,25864,236791,693487,203572,275336,294558,623921,614029,1041578,933777,970554,365265,610679,312090,634520,822325,601692,160435,573966,991854,603362,546462,72495,603744,862862,460114,231633,197406,830170,125720,644750,870180,795435,27217,712116,967501,935100,854795,296795,906482,606712,100142,1022085,1002686,778506,321345,985559,908367,450093,97114,606486,912317,452549,26594,902199,815439,496232,727977,477336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]