SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520776 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520776 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488919,792162,893796,383998,1035100,550947,903969,89553,567986,10896,324100,940942,80538,93745,574698,71641,392508,5129,417756,835074,1001239,877717,921777,517533,560371,996053,136655,55098,57077,503487,432204,543669,645619,801123,805031,570087,505964,647432,617408,401347,662266,181773,519457,346293,274168,944236,184791,420273,432806,848844,349206,327224,954257,472483,879658,1289,387628,261804,179008,534857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]