SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392300 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392300 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777875,780594,409810,235440,85235,879348,367410,94551,237937,50916,65407,406224,950116,181624,74375,284455,2653,467588,626198,302222,751559,59028,216944,671510,104554,939253,97312,989421,671318,483222,601268,465586,378530,867273,280880,959739,391148,969383,217694,1014124,39418,236808,237661,733344,964970,59438,191949,1027258,1008635,552367,572485,241477,885451,275468,308579,869789,639575,790747,656454,528496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]