SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59431 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59431 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028012,250010,589716,667236,722140,10915,416122,547381,609724,225204,971032,485149,551565,972061,640812,792259,531155,385716,934701,57214,808770,442156,601979,243269,774398,1036895,844783,535111,849992,351597,327857,544923,272692,442735,89738,123543,256823,712481,852082,221915,121851,1005510,135271,516875,219295,758308,604012,649306,54251,1036197,889458,620842,419318,276837,159205,786876,936737,925825,286081,988725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]