SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410906 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410906 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411226,680215,467513,575579,867608,210848,543385,279233,299408,331782,482713,156095,494403,837789,98118,787782,281512,198185,115936,326620,942000,176964,742014,656656,196268,632536,550681,335892,959085,131260,317820,172142,199098,434068,709753,1017437,498202,697919,201392,469453,494950,337112,719068,444774,226143,980310,596314,909386,267538,999948,886807,218676,771313,375633,964777,789984,894219,724000,1030293,495069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]