SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484317 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484317 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358121,61546,401250,5045,422838,651000,791220,248769,450334,635061,162921,593789,123315,285803,715700,817746,709903,338336,747580,872263,624116,126768,938565,513869,511178,862339,132378,238635,608406,772969,600898,132039,930133,685676,759029,938936,781078,205601,214078,413176,442681,85873,198970,439690,328373,244249,209246,532476,571554,930515,481305,309549,98531,119640,342127,88957,66167,849324,263529,865632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001283s ]