SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565614 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565614 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034215,357400,1018425,503258,157163,792400,877514,89086,478944,282355,279552,588295,531216,305587,266980,821919,582635,6279,669152,926404,1037220,383722,1007247,389896,194790,941526,585650,1045671,63606,867979,302338,672586,172075,383332,225281,906050,579782,906519,981982,524580,919575,947199,645870,19827,401917,619415,676507,919865,42145,377659,1043866,501044,338636,543139,999476,40581,871912,23742,880598,704544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]