SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549545 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549545 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348330,138787,194952,1025474,514082,508902,841313,815840,198540,212158,612930,279615,167149,328599,629972,1019249,335043,66032,1023598,820880,399263,130102,253654,597827,39974,19125,807186,512660,580680,397235,574411,791806,59404,642861,497744,65470,318086,359442,938658,436466,33887,270307,1042302,263101,124170,952883,980343,442068,937713,558635,916700,77503,1023186,297632,976190,496025,243073,22910,669740,136047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]