SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291048 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291048 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028608,231168,1041206,997187,661114,215055,910552,920682,359480,1005638,1143,1022476,910515,146951,859354,799706,750759,572631,36723,157857,823278,235000,278016,733144,76209,1025150,166495,504915,701974,5446,819093,191262,731442,694270,513553,396087,196235,633120,1029024,344703,195431,168356,799508,444254,817258,560950,533148,285031,13468,83367,514194,478479,135981,710246,560908,13878,948414,829810,256352,380253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]