SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104687 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104687 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825955,911777,286643,143928,606135,622125,381683,801155,466740,1035238,981824,535342,733560,949188,990401,446485,848657,5547,42669,830148,495617,311842,184970,324652,310594,919176,616602,338308,432462,591564,955630,225695,335168,955100,699376,998314,1041886,307880,955937,420157,209720,926601,729361,164111,330305,510599,1025138,862000,15850,138030,617168,326525,374093,790008,896788,603099,177217,397297,692240,1045848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]