SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100813 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100813 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482343,26732,1042951,196775,934120,393061,390872,111163,371022,500408,277491,609297,447819,170874,466160,403560,61112,603017,66465,599375,96162,229644,555460,330751,599034,844249,922467,270710,228576,383929,463560,826678,275273,215123,683862,740526,950773,141431,32376,716799,899244,420990,239127,318328,531374,607067,926359,569541,1033066,84514,394388,993092,219525,54371,2296,538621,122256,494548,215349,258329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]