SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104180 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104180 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623025,945409,963536,517844,886619,304715,367313,248432,592521,729034,138567,545162,619627,579540,271243,511402,689487,714195,684502,998710,676165,264182,265873,400803,503490,858649,580906,978958,874025,909547,753132,971785,137664,389583,795593,268839,127012,302743,169213,481921,159308,563017,332804,873278,1002476,894973,481940,126748,926555,539905,584549,182069,604749,557383,626185,630987,907542,165774,515648,124405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]