SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017412 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017412 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252863,5330,207037,1025791,188094,515004,680861,785897,965521,178915,368750,375858,195703,1002294,248965,941066,176064,119192,298218,1024716,1003868,815166,930554,374229,276497,990703,27298,899235,713636,716322,479691,371315,107164,330432,769487,82718,39652,90841,913004,1016076,322437,266110,575904,772740,573580,91471,786180,24404,568917,191383,964892,135289,109513,687057,459840,437364,1025545,578527,970889,202060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]