SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443093 LIMIT 1 [ RunTime:0.001891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443093 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432175,930815,487332,397543,246099,177089,470717,1042658,244443,792740,975230,128303,489493,152263,668459,356210,1473,754504,155208,981690,917926,86103,30764,578368,415902,222443,626525,576962,118590,221546,245806,1010458,696210,176396,85011,843013,221099,14731,494913,237742,886838,448226,493387,938165,808399,335490,450868,243332,937159,200947,214148,850815,643385,21585,10190,784813,885214,206017,94134,117678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]