SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200429 LIMIT 1 [ RunTime:0.001610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200429 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258828,609346,255683,245942,471142,843088,202770,302314,885902,944590,626919,377354,499640,273862,944787,74788,297715,375318,988642,126403,222552,488747,831633,369213,478999,154826,650793,898538,27302,659394,26047,656552,907245,629632,522024,33183,559118,491208,648889,662454,256659,910985,373308,625464,163198,599613,19164,315388,596292,380245,469183,149748,581982,1029763,239080,716731,353108,614192,561457,250932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]