SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358671 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358671 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638640,1025627,1017109,346428,705209,177145,996968,142121,773262,517523,201226,818458,346552,31083,470100,970076,853969,324571,694952,398557,386442,1005280,20035,675509,630086,597119,665684,620525,1014010,695924,860707,691306,636615,655116,735792,944733,522169,220739,203194,155158,215380,258724,770782,752104,458251,450206,308759,873969,316992,169695,828900,785652,619206,352115,316576,192875,993675,998206,568015,775835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]