SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505134 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505134 [ RunTime:0.006958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927125,666020,10430,455447,206124,855864,258273,800669,90779,51680,1014656,106997,889126,25321,219546,203428,881515,508173,849344,58579,267601,19874,950750,907231,883247,101450,845466,835688,1021597,144610,779532,122598,241212,728727,497692,678471,1030279,974911,22464,253041,211080,414623,716994,318381,156383,679438,869235,793748,786949,1011464,848598,1017117,855233,842994,424364,824618,473135,820597,747900,502601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]