SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581983 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581983 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825904,503777,612904,888146,429390,879833,928626,98742,112658,525452,333610,395190,486440,482768,384752,884168,1038571,112369,169984,317457,729270,189114,912481,427638,853970,415464,812563,300463,346392,688680,393695,842874,858010,817558,728056,776402,789346,154032,940114,18543,622135,809966,341054,142089,256449,306332,551486,83883,772684,688739,341399,229370,717382,661363,822115,456139,884681,714315,954583,1034648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]