SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045948 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045948 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99626,151519,811103,967130,651141,88492,930678,884767,158952,508986,455128,911615,438215,889051,924257,719944,353043,833428,298162,13540,560777,841385,775216,269454,102155,1036778,654412,906760,313724,999383,458480,1030316,948381,775899,400499,761549,1022538,884024,371204,390819,996345,99235,609264,380810,237894,62363,865613,764260,80879,632394,923501,233258,679565,531792,995354,433393,804845,515591,912621,212141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004183s ]