SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819118 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819118 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144524,413045,437209,1038772,85196,872437,541489,320181,381239,610990,331104,471753,1026113,716031,639949,852380,207768,1013939,105456,166190,274761,1000388,740653,197172,1001763,793048,682311,521766,523494,748324,725511,912834,560948,869358,386579,742258,230616,227144,521173,221188,4375,558910,127385,182019,793337,440763,950037,947486,360159,649750,829527,687568,437654,602853,717134,700353,133342,303314,600568,762603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]