SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535070 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535070 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738001,697428,298057,341152,773138,1010582,20635,536826,785113,132284,886885,729346,424810,345007,105504,997011,250190,73647,826573,535262,926929,347296,969541,542859,788731,677014,918930,263728,802146,126763,57323,987190,418974,22988,900364,190531,869699,103568,509184,440532,156701,890051,296217,218207,919663,1044307,352878,300828,201562,770639,470860,150290,973905,166610,1017155,931320,175431,275191,418424,618823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]