SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806996 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806996 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639532,13018,347133,266301,224715,1034629,580540,401802,50271,95646,691840,1035048,618473,685904,196041,372832,875063,935247,654035,316249,733539,225961,637949,611366,919468,1028014,917748,88373,915322,483376,735685,790301,1034486,750330,385288,11602,194243,549325,689534,96925,71392,29372,60939,442303,287598,295759,630121,997669,829538,47177,232968,1035783,1003429,951900,896114,623332,1020977,495013,622742,945956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]