SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224104 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224104 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504256,919490,823553,600140,608831,993289,212070,158871,280158,363485,310199,238624,192335,463453,757182,958259,176986,70339,897158,796331,942947,21134,199499,753645,707160,190630,805801,351638,586600,766789,217980,1029815,293510,747605,517784,703377,775247,832962,336768,558178,198479,226874,510401,84612,748562,55696,830987,466425,475042,916414,976486,927187,94206,263279,691315,736299,870510,100170,347692,138643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]