SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549896 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549896 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5145,705932,541686,214968,353502,172247,312007,849311,76674,57832,964845,222454,133652,170982,202882,220526,1025331,448983,203301,666798,1024484,243612,1001435,529880,944878,580405,243564,1014896,875307,602490,509782,535413,410660,467314,413328,259636,76490,808568,417024,584166,554371,880160,86812,725907,493984,314550,178302,548706,138651,671503,344061,65794,462545,286146,237461,370231,1000270,706405,639702,140519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]