SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516793 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516793 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88399,393819,731669,845738,553808,461891,1020977,379980,741007,103702,671763,630375,597902,572322,117572,1000660,876430,904927,905251,916734,93607,319028,105211,368669,226961,621650,582666,784382,667159,349152,229119,800117,411174,1024543,843938,487616,255913,1025416,721735,543114,815990,8109,547311,94255,680038,737260,624006,270181,664346,897737,748809,873048,985745,377190,904280,116743,891388,581681,923710,558510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]