SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545013 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545013 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808690,39970,1017545,239404,25230,909235,46260,463827,502605,654609,506862,512328,229975,668826,377102,424013,98708,324752,790894,782844,515737,626204,1030294,376563,894009,607709,853814,120044,357871,683378,757566,142964,26184,739541,952477,968655,508827,191507,486160,964444,234224,1003294,918982,275925,632465,752106,488546,764703,937063,734227,763076,9904,326246,16741,363265,500799,1012874,1033030,258042,253836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]