SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424014 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424014 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946217,837464,786383,397173,465289,14239,835833,568959,207513,425747,40908,505430,551141,433551,449048,179225,903867,683668,470974,280713,101834,1035991,269949,595747,188724,184316,493204,188378,29239,238543,651732,881511,531189,263405,41836,406813,247400,609579,628272,543080,556095,327731,52523,823952,962313,144041,506602,453791,43844,1014789,101925,309417,161236,6627,182872,533852,676075,704371,377245,895920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]