SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441028 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441028 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522003,682640,883411,582922,278212,705144,380724,717743,388635,28032,318925,600833,738049,825378,239471,438932,807002,401767,709113,951374,275731,393000,36639,983233,709172,940514,478307,990009,731971,460281,162727,902128,68881,30402,372385,59283,747855,704907,934191,304815,1016485,312119,963982,194545,103920,556207,426122,951461,907235,596753,135828,314142,316647,222116,117536,346755,293632,493917,674589,776141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]