SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576072 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576072 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204310,893079,795319,162778,269192,724322,57329,769047,1043086,563959,556936,171525,650828,557386,997001,445081,433791,771060,882167,276392,137485,199075,540245,9100,577645,234186,473128,299962,501431,262884,288157,569468,430510,373280,983826,166429,872713,215846,779085,938292,312559,584490,527317,924143,520400,373919,599501,1499,689554,800298,589459,66242,547366,524783,20338,775950,241590,93140,595721,564800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]