SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431813 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431813 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200593,153362,755368,774854,454210,914245,163507,1009614,389868,536241,985041,669925,149060,617184,133305,875733,868552,122117,245456,17317,687866,80611,796552,521680,242650,766495,960196,172736,442205,148206,965866,707000,156781,1046784,56028,559933,155996,340350,909163,542870,245863,623675,604743,425902,889373,282899,534,393161,365447,630036,935936,627326,386241,177542,297454,32893,697463,841829,152583,911977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]