SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538318 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538318 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573469,494408,955268,938044,957925,444481,30201,520095,358304,501375,520526,435971,75404,657681,204654,69278,263026,752818,962648,47095,997989,1006724,396980,435215,261059,345883,935822,964670,387349,356635,192422,820434,575204,558563,527287,499911,219034,363575,120250,872054,296648,157882,504194,418519,597877,576979,560959,785338,746957,1000786,192924,941992,803934,93173,574039,284832,729967,1006112,32619,471272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]