SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41938 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41938 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156587,43512,541297,227853,711119,513359,548057,485298,490885,73991,195952,566625,167074,931560,822843,153834,777122,330808,1039139,499687,431404,825151,797803,896715,804316,369563,615000,928715,894804,519410,1040260,792025,999692,1041070,1029167,407306,432464,799764,11967,263859,517413,959473,356005,900104,41610,297716,333756,84779,35713,86292,606440,251919,980821,777444,8443,47529,833284,860562,344131,841834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]