SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416112 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416112 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122567,918215,676221,470124,585156,1018562,757913,535241,361370,262054,538588,217047,898050,686839,336513,775733,466602,586800,386641,841009,653932,73213,1015346,645729,874001,559389,938088,625416,791767,140846,1014786,488422,235339,695797,83004,789886,924997,880773,571888,413560,648922,206254,530387,393607,793940,51148,178961,905625,151848,1010462,479285,519709,906443,939866,324561,621845,398744,399086,185893,596399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]