SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44672 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44672 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302611,1047359,202387,998598,376192,402975,5682,446387,203465,1042305,838831,625181,467787,505800,34758,724143,512493,392341,592400,387800,156000,585117,644403,455519,259186,607550,452564,286517,880029,696372,869062,6193,1021927,724069,193063,282421,733124,666724,208484,660059,1017578,963336,225822,609735,824933,544948,386101,397196,549960,1040730,848388,689836,989066,341144,407875,567856,689144,554612,99307,362760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]